<script>
const list = [
  {
    correctionTime: '2018-11-30',
    departmentName: '总裁办',
    formOfEmployment: 1,
    id: '604f764971f93f3ac8f365c2',
    mobile: '13800000002',
    password: 'e10adc3949ba59abbe56e057f20f883e',
    staffPhoto: 'http://q6cu3t6jv.bkt.clouddn.com/1063705989926227968?t=1616204161907',
    timeOfEntry: '2018-11-02',
    username: '管理员',
    workNumber: '9002'
  },
  {
    correctionTime: '2018-11-20',
    departmentName: '市场部',
    formOfEmployment: 1,
    id: '604f764971f93f3ac8f365c3',
    mobile: '13800000003',
    password: 'e10adc3949ba59abbe56e057f20f883e',
    staffPhoto: 'http://q6cu3t6jv.bkt.clouddn.com/1063705989926227968?t=1616204161907',
    timeOfEntry: '2018-11-04',
    username: '孙财',
    workNumber: '111'
  }
]

const mapInfo = {
  'id': '编号',
  'password': '密码',
  'mobile': '手机号',
  'username': '姓名',
  'timeOfEntry': '入职日期',
  'formOfEmployment': '聘用形式',
  'correctionTime': '转正日期',
  'workNumber': '工号',
  'departmentName': '部门',
  'staffPhoto': '头像地址'
}
function transZhKeyToExcel(list) {
  const one = list[0]
  if (!one) return
  const tHeader = Object.keys(one).map(enkey => {
    return mapInfo[enkey]
  })
  console.log(tHeader, 'tHeader')
  const data = list.map(item => {
    return Object.values(item)
  })
  console.log(data, 'data')
  return { tHeader, data }
}
const { tHeader, data } = transZhKeyToExcel(list)
console.log(tHeader, 'tHeader')
console.log(data, 'result')
</script>
